Overview

Dataset Statistics

Number of Variables 13
Number of Rows 105120
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 18.6 MB
Average Row Size in Memory 186.0 B
Variable Types
  • Categorical: 1
  • Numerical: 12

Dataset Insights

dpt_1_2_Prod_kW is skewed Skewed
enerpos_Prod_kW is skewed Skewed
esiroi_Prod_kW is skewed Skewed
GHI is skewed Skewed
BNI is skewed Skewed
DHI is skewed Skewed
Ws10 is skewed Skewed
Wd10 is skewed Skewed
Rainfall is skewed Skewed
datetime has a high cardinality: 105120 distinct values High Cardinality
datetime has constant length 25 Constant Length
datetime has all distinct values Unique
dpt_1_2_Prod_kW has 51731 (49.21%) negatives Negatives
esiroi_Prod_kW has 53826 (51.2%) negatives Negatives
enerpos_Prod_kW has 53916 (51.29%) zeros Zeros
GHI has 49372 (46.97%) zeros Zeros
BNI has 48926 (46.54%) zeros Zeros
DHI has 50060 (47.62%) zeros Zeros
Rainfall has 102238 (97.26%) zeros Zeros
  • 1
  • 2

Variables


datetime

categorical

Approximate Distinct Count 105120
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 9460800

Length

Mean 25
Standard Deviation 0
Median 25
Minimum 25
Maximum 25

Sample

1st row 2021-01-01 00:10:0...
2nd row 2021-01-01 00:20:0...
3rd row 2021-01-01 00:30:0...
4th row 2021-01-01 00:40:0...
5th row 2021-01-01 00:50:0...

Letter

Count 0
Lowercase Letter 0
Space Separator 105120
Uppercase Letter 0
Dash Punctuation 210240
Decimal Number 1892160
  • datetime has words of constant length

dpt_1_2_Prod_kW

numerical

Approximate Distinct Count 53482
Approximate Unique (%) 50.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 20.5312
Minimum -0.02257
Maximum 100.98
Zeros 0
Zeros (%) 0.0%
Negatives 51731
Negatives (%) 49.2%
  • dpt_1_2_Prod_kW is skewed right (γ1 = 1.0794)

Quantile Statistics

Minimum -0.02257
5-th Percentile -0.02257
Q1 -0.02257
Median 0.1718
Q3 40.1365
95-th Percentile 78.7548
Maximum 100.98
Range 101.0026
IQR 40.159

Descriptive Statistics

Mean 20.5312
Standard Deviation 28.4899
Variance 811.6757
Sum 2.1582e+06
Skewness 1.0794
Kurtosis -0.3419
Coefficient of Variation 1.3876
  • dpt_1_2_Prod_kW is not normally distributed (p-value 4.997008942235701e-25)
  • dpt_1_2_Prod_kW has 79 outliers

enerpos_Prod_kW

numerical

Approximate Distinct Count 51126
Approximate Unique (%) 48.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 8.3283
Minimum -0.02191
Maximum 44.852
Zeros 53916
Zeros (%) 51.3%
Negatives 104
Negatives (%) 0.1%
  • enerpos_Prod_kW is skewed right (γ1 = 1.1249)

Quantile Statistics

Minimum -0.02191
5-th Percentile 0
Q1 0
Median 0
Q3 16.3202
95-th Percentile 32.5664
Maximum 44.852
Range 44.8739
IQR 16.3202

Descriptive Statistics

Mean 8.3283
Standard Deviation 11.5866
Variance 134.2496
Sum 875466.667
Skewness 1.1249
Kurtosis -0.1159
Coefficient of Variation 1.3912
  • enerpos_Prod_kW is not normally distributed (p-value 5.049542891946593e-25)
  • enerpos_Prod_kW has 345 outliers

esiroi_Prod_kW

numerical

Approximate Distinct Count 51429
Approximate Unique (%) 48.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 1.9045
Minimum -0.005061
Maximum 9.3546
Zeros 0
Zeros (%) 0.0%
Negatives 53826
Negatives (%) 51.2%
  • esiroi_Prod_kW is skewed right (γ1 = 1.0599)

Quantile Statistics

Minimum -0.005061
5-th Percentile -0.002254
Q1 -0.002254
Median -0.002254
Q3 3.7718
95-th Percentile 7.2804
Maximum 9.3546
Range 9.3596
IQR 3.7741

Descriptive Statistics

Mean 1.9045
Standard Deviation 2.6454
Variance 6.9982
Sum 200197.2815
Skewness 1.0599
Kurtosis -0.4139
Coefficient of Variation 1.3891
  • esiroi_Prod_kW is not normally distributed (p-value 4.8932940335705535e-25)

GHI

numerical

Approximate Distinct Count 43308
Approximate Unique (%) 41.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 236.8802
Minimum 0
Maximum 1305.9
Zeros 49372
Zeros (%) 47.0%
Negatives 0
Negatives (%) 0.0%
  • GHI is skewed right (γ1 = 1.1488)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 3.8998
Q3 451.6675
95-th Percentile 933.6
Maximum 1305.9
Range 1305.9
IQR 451.6675

Descriptive Statistics

Mean 236.8802
Standard Deviation 328.7519
Variance 108077.8041
Sum 2.4901e+07
Skewness 1.1488
Kurtosis -0.04371
Coefficient of Variation 1.3878
  • GHI is not normally distributed (p-value 5.282224050178685e-25)
  • GHI has 376 outliers

BNI

numerical

Approximate Distinct Count 42520
Approximate Unique (%) 40.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 223.8563
Minimum 0
Maximum 1200.8944
Zeros 48926
Zeros (%) 46.5%
Negatives 0
Negatives (%) 0.0%
  • BNI is skewed right (γ1 = 1.0116)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0.1685
Q3 518.7525
95-th Percentile 849
Maximum 1200.8944
Range 1200.8944
IQR 518.7525

Descriptive Statistics

Mean 223.8563
Standard Deviation 328.6593
Variance 108016.9263
Sum 2.3532e+07
Skewness 1.0116
Kurtosis -0.7233
Coefficient of Variation 1.4682
  • BNI is not normally distributed (p-value 5.965823757102227e-25)

DHI

numerical

Approximate Distinct Count 44000
Approximate Unique (%) 41.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 81.6965
Minimum 0
Maximum 1046.9
Zeros 50060
Zeros (%) 47.6%
Negatives 0
Negatives (%) 0.0%
  • DHI is skewed right (γ1 = 1.9736)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 3.558
Q3 124.2225
95-th Percentile 354.7415
Maximum 1046.9
Range 1046.9
IQR 124.2225

Descriptive Statistics

Mean 81.6965
Standard Deviation 122.2309
Variance 14940.4048
Sum 8.5879e+06
Skewness 1.9736
Kurtosis 4.3107
Coefficient of Variation 1.4962
  • DHI is not normally distributed (p-value 4.013669994049639e-24)
  • DHI has 7229 outliers

DBT

numerical

Approximate Distinct Count 15874
Approximate Unique (%) 15.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 23.7785
Minimum 14.297
Maximum 33.992
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • DBT is skewed left (γ1 = -0.0048)

Quantile Statistics

Minimum 14.297
5-th Percentile 17.93
Q1 20.954
Median 23.918
Q3 26.341
95-th Percentile 29.711
Maximum 33.992
Range 19.695
IQR 5.387

Descriptive Statistics

Mean 23.7785
Standard Deviation 3.5856
Variance 12.8564
Sum 2.4996e+06
Skewness -0.004845
Kurtosis -0.7083
Coefficient of Variation 0.1508

RH

numerical

Approximate Distinct Count 28147
Approximate Unique (%) 26.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 74.2615
Minimum 0.08495
Maximum 100
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • RH is skewed left (γ1 = -0.1428)

Quantile Statistics

Minimum 0.08495
5-th Percentile 57.1399
Q1 67.075
Median 74.5005
Q3 81.58
95-th Percentile 90.88
Maximum 100
Range 99.9151
IQR 14.505

Descriptive Statistics

Mean 74.2615
Standard Deviation 10.1714
Variance 103.4568
Sum 7.8064e+06
Skewness -0.1428
Kurtosis -0.3036
Coefficient of Variation 0.137
  • RH has 148 outliers

Ws10

numerical

Approximate Distinct Count 47617
Approximate Unique (%) 45.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 2.3113
Minimum 0
Maximum 13.207
Zeros 570
Zeros (%) 0.5%
Negatives 0
Negatives (%) 0.0%
  • Ws10 is skewed right (γ1 = 0.8962)

Quantile Statistics

Minimum 0
5-th Percentile 0.103
Q1 0.6972
Median 1.8975
Q3 3.4613
95-th Percentile 6.0781
Maximum 13.207
Range 13.207
IQR 2.7641

Descriptive Statistics

Mean 2.3113
Standard Deviation 1.9371
Variance 3.7523
Sum 242959.227
Skewness 0.8962
Kurtosis 0.2558
Coefficient of Variation 0.8381
  • Ws10 is not normally distributed (p-value 8.009649063768399e-13)
  • Ws10 has 1083 outliers

Wd10

numerical

Approximate Distinct Count 55669
Approximate Unique (%) 53.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 122.588
Minimum 0.0824
Maximum 356.48
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Wd10 is skewed right (γ1 = 1.0658)

Quantile Statistics

Minimum 0.0824
5-th Percentile 42.5476
Q1 90.22
Median 113.36
Q3 135.5217
95-th Percentile 248.0624
Maximum 356.48
Range 356.3976
IQR 45.3017

Descriptive Statistics

Mean 122.588
Standard Deviation 58.6729
Variance 3442.5086
Sum 1.2886e+07
Skewness 1.0658
Kurtosis 1.2078
Coefficient of Variation 0.4786
  • Wd10 is not normally distributed (p-value 1.28446526725306e-07)
  • Wd10 has 13698 outliers

Patmo

numerical

Approximate Distinct Count 951
Approximate Unique (%) 0.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 1017.3305
Minimum 995.4
Maximum 1028
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Patmo is skewed left (γ1 = -0.3029)

Quantile Statistics

Minimum 995.4
5-th Percentile 1010
Q1 1014
Median 1017.4
Q3 1021
95-th Percentile 1024
Maximum 1028
Range 32.6
IQR 7

Descriptive Statistics

Mean 1017.3305
Standard Deviation 4.6391
Variance 21.5216
Sum 1.0694e+08
Skewness -0.3029
Kurtosis -0.09134
Coefficient of Variation 0.00456
  • Patmo is not normally distributed (p-value 0.008464718338540376)
  • Patmo has 550 outliers

Rainfall

numerical

Approximate Distinct Count 39
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 1681920
Mean 0.001471
Minimum 0
Maximum 1.32
Zeros 102238
Zeros (%) 97.3%
Negatives 0
Negatives (%) 0.0%
  • Rainfall is skewed right (γ1 = 29.1593)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 0
Maximum 1.32
Range 1.32
IQR 0

Descriptive Statistics

Mean 0.001471
Standard Deviation 0.01635
Variance 0.00026732
Sum 154.66
Skewness 29.1593
Kurtosis 1361.4423
Coefficient of Variation 11.1129
  • Rainfall is not normally distributed (p-value 4.232558175711224e-25)
  • Rainfall has 2882 outliers

Interactions

Correlations

Missing Values